KC Housing Report

Dataset info

Number of variables	21
Number of observations	21597
Missing cells	6281 (1.4%)
Duplicate rows	0 (0.0%)
Total size in memory	3.5 MiB
Average record size in memory	168.0 B

Variables types

Numeric	18
Categorical	2
Boolean	1
Date	0
URL	0
Text (Unique)	0
Rejected	0
Unsupported	0

Warnings

`date` has a high cardinality: 372 distinct values	Warning
`sqft_basement` has a high cardinality: 304 distinct values	Warning
`view` has 19422 (89.9%) zeros	Zeros
`waterfront` has 2376 (11.0%) missing values	Missing
`yr_renovated` has 17011 (78.8%) zeros	Zeros
`yr_renovated` has 3842 (17.8%) missing values	Missing

bathrooms
Numeric

Distinct count	29
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.115826272
Minimum	0.5
Maximum	8
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.5
5-th percentile	1
Q1	1.75
Median	2.25
Q3	2.5
95-th percentile	3.5
Maximum	8
Range	7.5
Interquartile range	0.75

Descriptive statistics

Standard deviation	0.7689842967
Coef of variation	0.3634439683
Kurtosis	1.279315294
Mean	2.115826272
MAD	0.6145972614
Skewness	0.5197092816
Sum	45695.5
Variance	0.5913368485
Memory size	168.9 KiB

Histogram with fixed size bins (bins=29)

Histogram with variable size bins (bins=[0.5 0.625 0.875 1.125 1.375 ... 4.125 4.625 5.375 6.125 8. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2.5	5377	24.9%
1	3851	17.8%
1.75	3048	14.1%
2.25	2047	9.5%
2	1930	8.9%
1.5	1445	6.7%
2.75	1185	5.5%
3	753	3.5%
3.5	731	3.4%
3.25	589	2.7%
Other values (19)	641	3.0%

Minimum 5 values

Value	Count	Frequency (%)
0.5	4	< 0.1%
0.75	71	0.3%
1	3851	17.8%
1.25	9	< 0.1%
1.5	1445	6.7%

Maximum 5 values

Value	Count	Frequency (%)
8	2	< 0.1%
7.75	1	< 0.1%
7.5	1	< 0.1%
6.75	2	< 0.1%
6.5	2	< 0.1%

bedrooms
Numeric

Distinct count	12
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.373199981
Minimum	1
Maximum	33
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	2
Q1	3
Median	3
Q3	4
95-th percentile	5
Maximum	33
Range	32
Interquartile range	1

Descriptive statistics

Standard deviation	0.9262988945
Coef of variation	0.2746053894
Kurtosis	49.82183475
Mean	3.373199981
MAD	0.7335737152
Skewness	2.023641235
Sum	72851
Variance	0.858029642
Memory size	168.9 KiB

Histogram with fixed size bins (bins=12)

Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 5.5 6.5 7.5 10.5 33. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
3	9824	45.5%
4	6882	31.9%
2	2760	12.8%
5	1601	7.4%
6	272	1.3%
1	196	0.9%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%
10	3	< 0.1%
Other values (2)	2	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
1	196	0.9%
2	2760	12.8%
3	9824	45.5%
4	6882	31.9%
5	1601	7.4%

Maximum 5 values

Value	Count	Frequency (%)
33	1	< 0.1%
11	1	< 0.1%
10	3	< 0.1%
9	6	< 0.1%
8	13	0.1%

condition
Numeric

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.409825439
Minimum	1
Maximum	5
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	3
Q1	3
Median	3
Q3	4
95-th percentile	5
Maximum	5
Range	4
Interquartile range	1

Descriptive statistics

Standard deviation	0.6505456357
Coef of variation	0.1907856127
Kurtosis	0.5192374924
Mean	3.409825439
MAD	0.5607545412
Skewness	1.036037425
Sum	73642
Variance	0.4232096241
Memory size	168.9 KiB

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
3	14020	64.9%
4	5677	26.3%
5	1701	7.9%
2	170	0.8%
1	29	0.1%

Minimum 5 values

Value	Count	Frequency (%)
1	29	0.1%
2	170	0.8%
3	14020	64.9%
4	5677	26.3%
5	1701	7.9%

Maximum 5 values

Value	Count	Frequency (%)
5	1701	7.9%
4	5677	26.3%
3	14020	64.9%
2	170	0.8%
1	29	0.1%

date
Categorical

Distinct count	372
Unique (%)	1.7%
Missing (%)	0.0%
Missing (n)	0

6/23/2014	142
6/25/2014	131
6/26/2014	131
Other values (369)	21193

Toggle details

Common values
Composition

Value	Count	Frequency (%)
6/23/2014	142	0.7%
6/25/2014	131	0.6%
6/26/2014	131	0.6%
7/8/2014	127	0.6%
4/27/2015	126	0.6%
3/25/2015	123	0.6%
7/9/2014	121	0.6%
4/28/2015	121	0.6%
4/22/2015	121	0.6%
4/14/2015	121	0.6%
Other values (362)	20333	94.1%

Max length	10
Mean length	8.924433949
Min length	8
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

floors
Numeric

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.494096402
Minimum	1
Maximum	3.5
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range	1

Descriptive statistics

Standard deviation	0.539682791
Coef of variation	0.3612101536
Kurtosis	-0.4910657592
Mean	1.494096402
MAD	0.4883540215
Skewness	0.6144969756
Sum	32268
Variance	0.2912575149
Memory size	168.9 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	10673	49.4%
2	8235	38.1%
1.5	1910	8.8%
3	611	2.8%
2.5	161	0.7%
3.5	7	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
1	10673	49.4%
1.5	1910	8.8%
2	8235	38.1%
2.5	161	0.7%
3	611	2.8%

Maximum 5 values

Value	Count	Frequency (%)
3.5	7	< 0.1%
3	611	2.8%
2.5	161	0.7%
2	8235	38.1%
1.5	1910	8.8%

grade
Numeric

Distinct count	11
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	7.657915451
Minimum	3
Maximum	13
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	3
5-th percentile	6
Q1	7
Median	7
Q3	8
95-th percentile	10
Maximum	13
Range	10
Interquartile range	1

Descriptive statistics

Standard deviation	1.173199664
Coef of variation	0.1532009163
Kurtosis	1.135148022
Mean	7.657915451
MAD	0.9287958624
Skewness	0.7882366364
Sum	165388
Variance	1.376397451
Memory size	168.9 KiB

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
7	8974	41.6%
8	6065	28.1%
9	2615	12.1%
6	2038	9.4%
10	1134	5.3%
11	399	1.8%
5	242	1.1%
12	89	0.4%
4	27	0.1%
13	13	0.1%

Minimum 5 values

Value	Count	Frequency (%)
3	1	< 0.1%
4	27	0.1%
5	242	1.1%
6	2038	9.4%
7	8974	41.6%

Maximum 5 values

Value	Count	Frequency (%)
13	13	0.1%
12	89	0.4%
11	399	1.8%
10	1134	5.3%
9	2615	12.1%

id
Numeric

Distinct count	21420
Unique (%)	99.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	4580474288
Minimum	1000102
Maximum	9900000190
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1000102
5-th percentile	512740390
Q1	2123049175
Median	3904930410
Q3	7308900490
95-th percentile	9297300412
Maximum	9900000190
Range	9899000088
Interquartile range	5185851315

Descriptive statistics

Standard deviation	2876735716
Coef of variation	0.6280431971
Kurtosis	-1.260749894
Mean	4580474288
MAD	2543785476
Skewness	0.243225522
Sum	9.892450319e+13
Variance	8.275608378e+18
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[1.00010200e+06 7.60006100e+06 7.60013050e+06 1.15005650e+07 1.15205050e+07 ... 9.83930020e+09 9.83930111e+09 9.84230007e+09 9.84230051e+09 9.90000019e+09], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
795000620	3	< 0.1%
1825069031	2	< 0.1%
2019200220	2	< 0.1%
7129304540	2	< 0.1%
1781500435	2	< 0.1%
3969300030	2	< 0.1%
2560801222	2	< 0.1%
3883800011	2	< 0.1%
2228900270	2	< 0.1%
251300110	2	< 0.1%
Other values (21410)	21576	99.9%

Minimum 5 values

Value	Count	Frequency (%)
1000102	2	< 0.1%
1200019	1	< 0.1%
1200021	1	< 0.1%
2800031	1	< 0.1%
3600057	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
9900000190	1	< 0.1%
9895000040	1	< 0.1%
9842300540	1	< 0.1%
9842300485	1	< 0.1%
9842300095	1	< 0.1%

lat
Numeric

Distinct count	5033
Unique (%)	23.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	47.56009299
Minimum	47.1559
Maximum	47.7776
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	47.1559
5-th percentile	47.3103
Q1	47.4711
Median	47.5718
Q3	47.678
95-th percentile	47.7497
Maximum	47.7776
Range	0.6217
Interquartile range	0.2069

Descriptive statistics

Standard deviation	0.1385517682
Coef of variation	0.002913193803
Kurtosis	-0.6757902106
Mean	47.56009299
MAD	0.1148176747
Skewness	-0.48552159
Sum	1027155.328
Variance	0.01919659246
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[47.1559 47.18955 47.19365 47.19585 47.2141 ... 47.70015 47.73735 47.74675 47.75945 47.7776 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
47.6624	17	0.1%
47.5491	17	0.1%
47.5322	17	0.1%
47.6846	17	0.1%
47.6711	16	0.1%
47.6886	16	0.1%
47.6955	16	0.1%
47.6647	15	0.1%
47.6904	15	0.1%
47.686	15	0.1%
Other values (5023)	21436	99.3%

Minimum 5 values

Value	Count	Frequency (%)
47.1559	1	< 0.1%
47.1593	1	< 0.1%
47.1622	1	< 0.1%
47.1647	1	< 0.1%
47.1764	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
47.7776	3	< 0.1%
47.7775	3	< 0.1%
47.7774	1	< 0.1%
47.7772	3	< 0.1%
47.7771	2	< 0.1%

long
Numeric

Distinct count	751
Unique (%)	3.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	-122.2139825
Minimum	-122.519
Maximum	-121.315
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	-122.519
5-th percentile	-122.387
Q1	-122.328
Median	-122.231
Q3	-122.125
95-th percentile	-121.9798
Maximum	-121.315
Range	1.204
Interquartile range	0.203

Descriptive statistics

Standard deviation	0.1407235288
Coef of variation	-0.001151451953
Kurtosis	1.052120317
Mean	-122.2139825
MAD	0.1150902288
Skewness	0.8848883395
Sum	-2639455.38
Variance	0.01980311157
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[-122.519 -122.466 -122.442 -122.4155 -122.4125 ... -121.7685 -121.7435 -121.6945 -121.411 -121.315 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
-122.29	115	0.5%
-122.3	111	0.5%
-122.362	104	0.5%
-122.291	100	0.5%
-122.372	99	0.5%
-122.363	99	0.5%
-122.288	98	0.5%
-122.357	96	0.4%
-122.284	95	0.4%
-122.172	94	0.4%
Other values (741)	20586	95.3%

Minimum 5 values

Value	Count	Frequency (%)
-122.519	1	< 0.1%
-122.515	1	< 0.1%
-122.514	1	< 0.1%
-122.512	1	< 0.1%
-122.511	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
-121.315	2	< 0.1%
-121.316	1	< 0.1%
-121.319	1	< 0.1%
-121.321	1	< 0.1%
-121.325	1	< 0.1%

price
Numeric

Distinct count	3622
Unique (%)	16.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	540296.5735
Minimum	78000
Maximum	7700000
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	78000
5-th percentile	210000
Q1	322000
Median	450000
Q3	645000
95-th percentile	1160000
Maximum	7700000
Range	7622000
Interquartile range	323000

Descriptive statistics

Standard deviation	367368.1401
Coef of variation	0.6799379417
Kurtosis	34.54135858
Mean	540296.5735
MAD	234028.1757
Skewness	4.023364652
Sum	1.16687851e+10
Variance	1.349593504e+11
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 78000. 109750. 149950. 150275. 159997.5 ... 2005000. 2590000. 3410000. 3825000. 7700000. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
350000	172	0.8%
450000	172	0.8%
550000	159	0.7%
500000	152	0.7%
425000	150	0.7%
325000	148	0.7%
400000	145	0.7%
375000	138	0.6%
300000	133	0.6%
525000	131	0.6%
Other values (3612)	20097	93.1%

Minimum 5 values

Value	Count	Frequency (%)
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82000	1	< 0.1%
82500	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
7700000	1	< 0.1%
7060000	1	< 0.1%
6890000	1	< 0.1%
5570000	1	< 0.1%
5350000	1	< 0.1%

sqft_above
Numeric

Distinct count	942
Unique (%)	4.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1788.596842
Minimum	370
Maximum	9410
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	370
5-th percentile	850
Q1	1190
Median	1560
Q3	2210
95-th percentile	3400
Maximum	9410
Range	9040
Interquartile range	1020

Descriptive statistics

Standard deviation	827.7597612
Coef of variation	0.4627984024
Kurtosis	3.405519761
Mean	1788.596842
MAD	640.1909905
Skewness	1.447434235
Sum	38628326
Variance	685186.2222
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 370. 545. 665. 695. 762.5 ... 4505. 4775. 5485. 6690. 9410. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1300	212	1.0%
1010	210	1.0%
1200	206	1.0%
1220	192	0.9%
1140	184	0.9%
1400	180	0.8%
1060	178	0.8%
1180	177	0.8%
1340	176	0.8%
1250	174	0.8%
Other values (932)	19708	91.3%

Minimum 5 values

Value	Count	Frequency (%)
370	1	< 0.1%
380	1	< 0.1%
390	1	< 0.1%
410	1	< 0.1%
420	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
9410	1	< 0.1%
8860	1	< 0.1%
8570	1	< 0.1%
8020	1	< 0.1%
7880	1	< 0.1%

sqft_basement
Categorical

Distinct count	304
Unique (%)	1.4%
Missing (%)	0.0%
Missing (n)	0

0.0	12826
?	454
600.0	217
Other values (301)	8100

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0.0	12826	59.4%
?	454	2.1%
600.0	217	1.0%
500.0	209	1.0%
700.0	208	1.0%
800.0	201	0.9%
400.0	184	0.9%
1000.0	148	0.7%
300.0	142	0.7%
900.0	142	0.7%
Other values (294)	6866	31.8%

Max length	6
Mean length	3.816039265
Min length	1
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

sqft_living
Numeric

Distinct count	1034
Unique (%)	4.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2080.32185
Minimum	370
Maximum	13540
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	370
5-th percentile	940
Q1	1430
Median	1910
Q3	2550
95-th percentile	3760
Maximum	13540
Range	13170
Interquartile range	1120

Descriptive statistics

Standard deviation	918.1061251
Coef of variation	0.4413288862
Kurtosis	5.252101951
Mean	2080.32185
MAD	698.0845425
Skewness	1.473215455
Sum	44928711
Variance	842918.8569
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 370. 510. 665. 695. 804.5 ... 4755. 5560. 6077.5 8015. 13540. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1300	138	0.6%
1400	135	0.6%
1440	133	0.6%
1660	129	0.6%
1010	129	0.6%
1800	129	0.6%
1820	128	0.6%
1480	125	0.6%
1720	125	0.6%
1540	124	0.6%
Other values (1024)	20302	94.0%

Minimum 5 values

Value	Count	Frequency (%)
370	1	< 0.1%
380	1	< 0.1%
390	1	< 0.1%
410	1	< 0.1%
420	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
13540	1	< 0.1%
12050	1	< 0.1%
10040	1	< 0.1%
9890	1	< 0.1%
9640	1	< 0.1%

sqft_living15
Numeric

Distinct count	777
Unique (%)	3.6%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1986.620318
Minimum	399
Maximum	6210
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	399
5-th percentile	1140
Q1	1490
Median	1840
Q3	2360
95-th percentile	3300
Maximum	6210
Range	5811
Interquartile range	870

Descriptive statistics

Standard deviation	685.2304719
Coef of variation	0.3449227141
Kurtosis	1.591732789
Mean	1986.620318
MAD	536.1565539
Skewness	1.106875397
Sum	42905039
Variance	469540.7996
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 399. 680. 829. 975. 994. ... 3755. 3995. 4325. 4945. 6210.], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1540	197	0.9%
1440	195	0.9%
1560	192	0.9%
1500	180	0.8%
1460	169	0.8%
1580	167	0.8%
1610	166	0.8%
1800	166	0.8%
1720	166	0.8%
1620	164	0.8%
Other values (767)	19835	91.8%

Minimum 5 values

Value	Count	Frequency (%)
399	1	< 0.1%
460	2	< 0.1%
620	2	< 0.1%
670	1	< 0.1%
690	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
6210	1	< 0.1%
6110	1	< 0.1%
5790	6	< 0.1%
5610	1	< 0.1%
5600	1	< 0.1%

sqft_lot
Numeric

Distinct count	9776
Unique (%)	45.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	15099.40876
Minimum	520
Maximum	1651359
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	520
5-th percentile	1800.8
Q1	5040
Median	7618
Q3	10685
95-th percentile	43307.2
Maximum	1651359
Range	1650839
Interquartile range	5645

Descriptive statistics

Standard deviation	41412.63688
Coef of variation	2.742666122
Kurtosis	285.4958119
Mean	15099.40876
MAD	13825.41475
Skewness	13.07260357
Sum	326101931
Variance	1715006493
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[5.200000e+02 6.755000e+02 8.635000e+02 1.154500e+03 1.351500e+03 ... 2.178025e+05 2.246055e+05 2.942475e+05 5.061020e+05 1.651359e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
5000	358	1.7%
6000	290	1.3%
4000	251	1.2%
7200	220	1.0%
7500	119	0.6%
4800	119	0.6%
4500	114	0.5%
8400	111	0.5%
9600	109	0.5%
3600	103	0.5%
Other values (9766)	19803	91.7%

Minimum 5 values

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1651359	1	< 0.1%
1164794	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982998	1	< 0.1%

sqft_lot15
Numeric

Distinct count	8682
Unique (%)	40.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	12758.28351
Minimum	651
Maximum	871200
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	651
5-th percentile	2002.4
Q1	5100
Median	7620
Q3	10083
95-th percentile	37045.2
Maximum	871200
Range	870549
Interquartile range	4983

Descriptive statistics

Standard deviation	27274.44195
Coef of variation	2.137783027
Kurtosis	151.3956625
Mean	12758.28351
MAD	10102.39581
Skewness	9.524361965
Sum	275540649
Variance	743895183.7
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[6.510000e+02 9.145000e+02 1.056500e+03 1.168000e+03 1.279500e+03 ... 2.177945e+05 2.180110e+05 2.245520e+05 4.364705e+05 8.712000e+05], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
5000	427	2.0%
4000	356	1.6%
6000	288	1.3%
7200	210	1.0%
4800	145	0.7%
7500	142	0.7%
8400	116	0.5%
4500	111	0.5%
3600	111	0.5%
5100	109	0.5%
Other values (8672)	19582	90.7%

Minimum 5 values

Value	Count	Frequency (%)
651	1	< 0.1%
659	1	< 0.1%
660	1	< 0.1%
748	2	< 0.1%
750	4	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
871200	1	< 0.1%
858132	1	< 0.1%
560617	1	< 0.1%
438213	1	< 0.1%
434728	1	< 0.1%

view
Numeric

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.3%
Missing (n)	63
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.2338627287
Minimum	0
Maximum	4
Zeros (%)	89.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	2
Maximum	4
Range	4
Interquartile range	0

Descriptive statistics

Standard deviation	0.7656862012
Coef of variation	3.274083927
Kurtosis	10.91971254
Mean	0.2338627287
MAD	0.4218521331
Skewness	3.399525635
Sum	5036
Variance	0.5862753587
Memory size	168.9 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	19422	89.9%
2	957	4.4%
3	508	2.4%
1	330	1.5%
4	317	1.5%
(Missing)	63	0.3%

Minimum 5 values

Value	Count	Frequency (%)
0	19422	89.9%
1	330	1.5%
2	957	4.4%
3	508	2.4%
4	317	1.5%

Maximum 5 values

Value	Count	Frequency (%)
4	317	1.5%
3	508	2.4%
2	957	4.4%
1	330	1.5%
0	19422	89.9%

waterfront
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	11.0%
Missing (n)	2376

0	19075
1	146
(Missing)	2376

Toggle details

Value	Count	Frequency (%)
0	19075	88.3%
1	146	0.7%
(Missing)	2376	11.0%

yr_built
Numeric

Distinct count	116
Unique (%)	0.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1970.999676
Minimum	1900
Maximum	2015
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1951
Median	1975
Q3	1997
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range	46

Descriptive statistics

Standard deviation	29.37523413
Coef of variation	0.01490372347
Kurtosis	-0.6576944258
Mean	1970.999676
MAD	24.56634737
Skewness	-0.4694499765
Sum	42567680
Variance	862.9043803
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[1900. 1900.5 1904.5 1909.5 1910.5 ... 2009.5 2011.5 2013.5 2014.5 2015. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2014	559	2.6%
2006	453	2.1%
2005	450	2.1%
2004	433	2.0%
2003	420	1.9%
2007	417	1.9%
1977	417	1.9%
1978	387	1.8%
1968	381	1.8%
2008	367	1.7%
Other values (106)	17313	80.2%

Minimum 5 values

Value	Count	Frequency (%)
1900	87	0.4%
1901	29	0.1%
1902	27	0.1%
1903	46	0.2%
1904	45	0.2%

Maximum 5 values

Value	Count	Frequency (%)
2015	38	0.2%
2014	559	2.6%
2013	201	0.9%
2012	170	0.8%
2011	130	0.6%

yr_renovated
Numeric

Distinct count	71
Unique (%)	0.3%
Missing (%)	17.8%
Missing (n)	3842
Infinite (%)	0.0%
Infinite (n)	0

Mean	83.63677837
Minimum	0
Maximum	2015
Zeros (%)	78.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	2015
Range	2015
Interquartile range	0

Descriptive statistics

Standard deviation	399.9464139
Coef of variation	4.781944279
Kurtosis	18.91954345
Mean	83.63677837
MAD	160.2641776
Skewness	4.573385242
Sum	1484971
Variance	159957.134
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	17011	78.8%
2014	73	0.3%
2003	31	0.1%
2013	31	0.1%
2007	30	0.1%
2005	29	0.1%
2000	29	0.1%
1990	22	0.1%
2004	22	0.1%
2009	21	0.1%
Other values (60)	456	2.1%
(Missing)	3842	17.8%

Minimum 5 values

Value	Count	Frequency (%)
0	17011	78.8%
1934	1	< 0.1%
1940	2	< 0.1%
1944	1	< 0.1%
1945	3	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
2015	14	0.1%
2014	73	0.3%
2013	31	0.1%
2012	8	< 0.1%
2011	9	< 0.1%

zipcode
Numeric

Distinct count	70
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	98077.95185
Minimum	98001
Maximum	98199
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	98001
5-th percentile	98004
Q1	98033
Median	98065
Q3	98118
95-th percentile	98177
Maximum	98199
Range	198
Interquartile range	85

Descriptive statistics

Standard deviation	53.51307235
Coef of variation	0.0005456177596
Kurtosis	-0.8540048606
Mean	98077.95185
MAD	46.730101
Skewness	0.4053221913
Sum	2118189526
Variance	2863.648913
Memory size	168.9 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[98001. 98001.5 98002.5 98004.5 98005.5 ... 98151.5 98183. 98193. 98198.5 98199. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
98103	602	2.8%
98038	589	2.7%
98115	583	2.7%
98052	574	2.7%
98117	553	2.6%
98042	547	2.5%
98034	545	2.5%
98118	507	2.3%
98023	499	2.3%
98006	498	2.3%
Other values (60)	16100	74.5%

Minimum 5 values

Value	Count	Frequency (%)
98001	361	1.7%
98002	199	0.9%
98003	280	1.3%
98004	317	1.5%
98005	168	0.8%

Maximum 5 values

Value	Count	Frequency (%)
98199	317	1.5%
98198	280	1.3%
98188	136	0.6%
98178	262	1.2%
98177	255	1.2%

First rows

	bathrooms	bedrooms	condition	date	floors	grade	id	lat	long	price	sqft_above	sqft_basement	sqft_living	sqft_living15	sqft_lot	sqft_lot15	view	waterfront	yr_built	yr_renovated	zipcode
0	1.00	3	3	10/13/2014	1.0	7	7129300520	47.5112	-122.257	221900.0	1180	0.0	1180	1340	5650	5650	0.0	NaN	1955	0.0	98178
1	2.25	3	3	12/9/2014	2.0	7	6414100192	47.7210	-122.319	538000.0	2170	400.0	2570	1690	7242	7639	0.0	0.0	1951	1991.0	98125
2	1.00	2	3	2/25/2015	1.0	6	5631500400	47.7379	-122.233	180000.0	770	0.0	770	2720	10000	8062	0.0	0.0	1933	NaN	98028
3	3.00	4	5	12/9/2014	1.0	7	2487200875	47.5208	-122.393	604000.0	1050	910.0	1960	1360	5000	5000	0.0	0.0	1965	0.0	98136
4	2.00	3	3	2/18/2015	1.0	8	1954400510	47.6168	-122.045	510000.0	1680	0.0	1680	1800	8080	7503	0.0	0.0	1987	0.0	98074
5	4.50	4	3	5/12/2014	1.0	11	7237550310	47.6561	-122.005	1230000.0	3890	1530.0	5420	4760	101930	101930	0.0	0.0	2001	0.0	98053
6	2.25	3	3	6/27/2014	2.0	7	1321400060	47.3097	-122.327	257500.0	1715	?	1715	2238	6819	6819	0.0	0.0	1995	0.0	98003
7	1.50	3	3	1/15/2015	1.0	7	2008000270	47.4095	-122.315	291850.0	1060	0.0	1060	1650	9711	9711	NaN	0.0	1963	0.0	98198
8	1.00	3	3	4/15/2015	1.0	7	2414600126	47.5123	-122.337	229500.0	1050	730.0	1780	1780	7470	8113	0.0	0.0	1960	0.0	98146
9	2.50	3	3	3/12/2015	2.0	7	3793500160	47.3684	-122.031	323000.0	1890	0.0	1890	2390	6560	7570	0.0	0.0	2003	0.0	98038

Last rows

	bathrooms	bedrooms	condition	date	floors	grade	id	lat	long	price	sqft_above	sqft_basement	sqft_living	sqft_living15	sqft_lot	sqft_lot15	view	waterfront	yr_built	zipcode
21587	2.50	3	3	8/25/2014	2.0	8	7852140040	47.5389	-121.881	507250.0	2270	0.0	2270	2270	5536	5731	0.0	NaN	2003	98065
21588	2.00	3	3	1/26/2015	3.0	8	9834201367	47.5699	-122.288	429000.0	1490	0.0	1490	1400	1126	1230	0.0	0.0	2014	98144
21589	2.50	4	3	10/14/2014	2.0	9	3448900210	47.5137	-122.167	610685.0	2520	0.0	2520	2520	6023	6023	NaN	0.0	2014	98056
21590	3.50	4	3	3/26/2015	2.0	9	7936000429	47.5537	-122.398	1010000.0	2600	910.0	3510	2050	7200	6200	0.0	0.0	2009	98136
21591	2.50	3	3	2/19/2015	2.0	8	2997800021	47.5773	-122.409	475000.0	1180	130.0	1310	1330	1294	1265	0.0	0.0	2008	98116
21592	2.50	3	3	5/21/2014	3.0	8	263000018	47.6993	-122.346	360000.0	1530	0.0	1530	1530	1131	1509	0.0	0.0	2009	98103
21593	2.50	4	3	2/23/2015	2.0	8	6600060120	47.5107	-122.362	400000.0	2310	0.0	2310	1830	5813	7200	0.0	0.0	2014	98146
21594	0.75	2	3	6/23/2014	2.0	7	1523300141	47.5944	-122.299	402101.0	1020	0.0	1020	1020	1350	2007	0.0	0.0	2009	98144
21595	2.50	3	3	1/16/2015	2.0	8	291310100	47.5345	-122.069	400000.0	1600	0.0	1600	1410	2388	1287	0.0	NaN	2004	98027
21596	0.75	2	3	10/15/2014	2.0	7	1523300157	47.5941	-122.299	325000.0	1020	0.0	1020	1020	1076	1357	0.0	0.0	2008	98144

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows